| NO |
欄位代號 |
鍵值 |
欄位名稱 |
型態 |
長度 |
NULL |
預設值 |
說明 |
| 1 |
oasum001 |
 |
表單代號
|
nvarchar |
30 |
|
|
|
| 2 |
oasum002 |
 |
表單單號
|
nvarchar |
40 |
|
|
|
| 3 |
oasum003 |
 |
序號 |
nvarchar |
4 |
|
|
|
| 4 |
oasum004 |
|
日期 |
nvarchar |
20 |
|
|
|
| 5 |
oasum005 |
|
起始地點 |
nvarchar |
20 |
|
|
|
| 6 |
oasum006 |
|
到達地點 |
nvarchar |
20 |
|
|
|
| 7 |
oasum007 |
|
機票款金額 |
FLOAT |
|
|
0 |
|
| 8 |
oasum008 |
|
輪船費金額 |
FLOAT |
|
|
0 |
|
| 9 |
oasum009 |
|
車票金額 |
FLOAT |
|
|
0 |
|
| 10 |
oasum010 |
|
租車金額 |
FLOAT |
|
|
0 |
|
| 11 |
oasum011 |
|
計程車資金額 |
FLOAT |
|
|
0 |
|
| 12 |
oasum012 |
|
住宿費金額 |
FLOAT |
|
|
0 |
|
| 13 |
oasum013 |
|
手續費金額 |
FLOAT |
|
|
0 |
|
| 14 |
oasum014 |
|
運費金額 |
FLOAT |
|
|
0 |
|
| 15 |
oasum015 |
|
交際費金額 |
FLOAT |
|
|
0 |
|
| 16 |
oasum016 |
|
其他費用金額 |
FLOAT |
|
|
0 |
|
|